SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbSTiposDeSoporte
AS
SELECT     dbo.vwrSAreasInformaticas.Descripcion AS AreaInformatica
FROM         dbo.Tb_STiposDeSoporte RIGHT OUTER JOIN
                      dbo.vwrSAreasInformaticas ON dbo.Tb_STiposDeSoporte.IDAreaInformatica = dbo.vwrSAreasInformaticas.ID
GO
GRANT SELECT ON  [dbo].[vwbSTiposDeSoporte] TO [Informatica]
GRANT SELECT ON  [dbo].[vwbSTiposDeSoporte] TO [SoloVer]
GRANT SELECT ON  [dbo].[vwbSTiposDeSoporte] TO [Soporte]
GO
